Caution! If the version number of the database is higher than that supported by DB Maintenance, do not use any database commands until you resolve the version conflict.
To run DB Maintenance
1. From the Start menu, select DB Maintenance Utility in the iMIS program group.
2. When prompted, specify your server and database.
3. Log in using the sa user.
The next time you run DB Maintenance, it remembers the connection and only requires your password.
4. Verify that the version number supported by DB Maintenance (which appears at top, in the title bar) is the same or greater than the version number displayed to the right of the Database name (which is that of the database you selected).
Caution! Never run an older version of DB Maintenance against a newer database.
5. Click on any of the tabs to bring it to the front.
6. As needed, run the commands presented by the interface.
7. If you receive an error, check whether it's one of these known situations:
□ Column ... has the wrong default. Expected ... '', found '': a harmless error that might be triggered by upgraded databases.
□ "Wrong Ordinal" error on certain table columns may be triggered by upgraded databases. This message is generally harmless and affects only the ability to load the affected tables with BCP and the format files created by ASI.
Precautions for using DB Maintenance
■ Verify that you have a valid backup of your iMIS database before running DB Maintenance commands that modify the database.
■ Ensure the database is protected from updates before modifying it, to prevent failures and data problems from changes occurring while entities are being reset/rebuilt/removed:
1. Have all users log out.
2. Stop webservers from updating the database, such as by stopping the AppPool in IIS.
■ While users are logged in, you can safely run Analyze Database and Table Details; however, analyzing the database can affect performance.